<html>
<head>
<title>Save officer</title>
</head>
<body>
<?php

		//*** Update Record ***//
		$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
		$objDB = mysql_select_db("book_db");
		$strSQL=mysql_query("SET NAMES TIS620");
		$strSQL = "UPDATE officer ";
		$strSQL .=" SET  username = '".$_POST["username"]."', password = '".$_POST["password"]."', OfficerName = '".$_POST["officername"]."',officernum = '".$_POST["officernum"]."',  OfficerBirth = '".$_POST["officerbirth"]."', OfficerAddress = '".$_POST["officeraddress"]."', OfficerTel = '".$_POST["officertel"]."',OfficerEmail = '".$_POST["officeremail"]."', status = '".$_POST["status"]."' WHERE OfficerID= '".$_GET["OfficerID"]."' ";
		$objQuery = mysql_query($strSQL);		
	
	echo "Edit Complete<br>";
	echo "<meta http-equiv=refresh content=1;URL=officer_admin.php>";
	
	
?>

</body>
</html>